'Declaration
 
Public Overloads Shared Function SortBy( _
   ByVal worksheet As IWorksheet, _
   ByVal range As Reference, _
   ByVal columnIndexes() As Integer, _
   ByVal sortOns() As SortOn, _
   ByVal sortValues() As Object, _
   ByVal sortOrders() As SortOrder _
) As SortCommand

'Usage
 
Dim worksheet As IWorksheet
Dim range As Reference
Dim columnIndexes() As Integer
Dim sortOns() As SortOn
Dim sortValues() As Object
Dim sortOrders() As SortOrder
Dim value As SortCommand
 
value = SortCommand.SortBy(worksheet, range, columnIndexes, sortOns, sortValues, sortOrders)

public static SortCommand SortBy( 
   IWorksheet worksheet,
   Reference range,
   int[] columnIndexes,
   SortOn[] sortOns,
   object[] sortValues,
   SortOrder[] sortOrders
)

Parameters

worksheet

The worksheet to sort.

range

The sorting range.

columnIndexes

The indexes of sorting columns.

sortOns

A GrapeCity.Spreadsheet.SortOn array that indicates which data will be sorted.

sortValues

An array that indicates sorting values.

sortOrders

A GrapeCity.Spreadsheet.SortOrder array that indicates the sorting order.

Reference

SortCommand Class
SortCommand Members
Overload List